﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="UsefulTips_All.aspx.vb" Inherits="Travelling_Alone.UsefulTips_All" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<style type="text/css">
    .style1
    {
        font-size: x-large;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<p class="style1">
        Select &quot;Read Full&quot; to read a Useful Tip in detail!</p>
    <p class="style1">
        <asp:GridView ID="GridView1" runat="server" Font-Size="Medium" 
            AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="the_author" HeaderText="Author" 
                    SortExpression="the_author" />
                <asp:BoundField DataField="the_title" HeaderText="Title" 
                    SortExpression="the_title" />
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="UsefulTip_Detail.aspx?ID={0}" 
                    HeaderText="More Detail" Text="Read Full &gt;&gt;&gt; " />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:TravellingAloneConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:TravellingAloneConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM [useful_tips]"></asp:SqlDataSource>
    </p>

</asp:Content>
